Me too. I had the some problem. And couldn't figure out why when I was using tomcat. The point is that the docs at
jakarta.apache.orgdo not really explain the use of the parameters for me. If you use some database as a datasource, the
connectionswill go back into the pool, for a while and get recycled, so you should never call connection.close() when
youretrieve a database using a DataSource object from a jndi tree. Just don't forget to set the <maxIdle> parameter to
aacceptable high value (higher that the <maxActive> parameter which is the number of connections that are actually
openedby tomcat to process any request). This way the connections will get pooled and recycled correctly.
>I had this error as well, and tracked it down to my trying to use a
>Connnection object that had been closed.
>
>-----Original Message-----
>From: pgsql-jdbc-owner@postgresql.org
>[mailto:pgsql-jdbc-owner@postgresql.org] On Behalf Of Email User
>Sent: Wednesday, November 06, 2002 12:35 AM
>To: daniel.germain@gipsynet.com
>Cc: pgsql-jdbc@postgresql.org
>Subject: [JDBC] Query Executor Problem
>Hi,
>Our web based application which is using postgresql version 7.1.3
>java.lang.NullPointerException
> at
>org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:61)